Hledáme učitelku / učitele do první třídy.
30.
6
day) {
echo "$dataRow->title
"; echo "$dataRow->short_text
"; } else { echo "Nejbližší událost
"; echo "Konec školního roku
"; } ?>
"; echo "$dataRow->short_text
"; } else { echo "Nejbližší událost
"; echo "Konec školního roku
"; } ?>
Fotogalerie
id) { // dibi::test ("select id, article_date, title, short_text from article where site_id=%i and label & %i order by article_date desc", $mpID->id, 1); $dataRes=dibi::query("select id, article_date, title, short_text from article where parent_id=%i and label_id & %i and state=%i and deletedby=%i order by article_date desc limit 6", $mpID->id, 8, 1, 0); if(count($dataRes)>0) { foreach($dataRes as $dataRow) { $url="/site-photo/".str_pad($dataRow->id, 4, "0", STR_PAD_LEFT); $Fid=str_pad($dataRow->id, 4, "0", STR_PAD_LEFT); echo "title\">
![\"$dataRow-](\"$url/000_sml.jpg\")
title\" class=\"shadow\" />\n";
}
// echo "";
echo "více"; } else echo "V této sekci není žádná fotogalerie."; } else echo "V této sekci není žádná fotogalerie."; ?>
$hrefTitle
"; if($mpID->id) { // dibi::test ("select id, article_date, title, short_text from article where site_id=%i and label & %i order by article_date desc limit 5", $mpID->id, 1); $dataRes=dibi::query("select id, article_date, title, short_text from article where parent_id=%i and label_id & %i and state=%i and deletedby=%i order by article_date desc limit 3", $mpID->id, 1, 1, 0); if(count($dataRes)>0) { foreach($dataRes as $dataRow) { echo "
".date("j.n.Y", strtotime($dataRow->article_date))."
id\">$dataRow->title
$dataRow->short_text
"; } else echo "V této sekci není žádný článek."; } else echo "V této sekci není žádný článek."; ?>
id) {
echo "".date("j.n.Y", strtotime($dataRow->article_date))."
\n"; echo "title\" />$dataRow->title\n";
}
} else echo "Stránka neobsahuje žádné fotogalerie.";
} else echo "Stránka neobsahuje žádné fotogalerie.";
}
break;
case "zs-clanky":
case "ms-clanky":
case "babyklub-aktuality":
case "druzina-clanky":
case "anglictina-clanky":
if($_GET["id"]) {
$dataRow=dibi::fetch("select * from article where id=%i and state=%i and deletedby=%i", $_GET["id"], 1, 0);
if($dataRow->id) {
echo "
".date("j.n.Y", strtotime($dataRow->article_date))."
"; ksort($aFile); foreach ($aFile as $file) { // echo $file."
"; $url=str_replace("\\","/",$file); $name=substr($file,strrpos($file,"/")+1); $name=str_replace("-"," ",$name); $ext=substr($file,strrpos($file,".")+1); echo "![\"$name\"](\"img/icons/ico_$ext.gif\")
$name\n"; } } } } else echo "Požadovaný článek neexistuje."; $pg=$dataRow->id; } else { if($mpID->id) { // dibi::test ("select id, article_date, title, short_text from article where parent_id=%i and label_id & %i and state=%i and deletedby=%i order by article_date desc", $mpID->id, 1, 1, 0); $dataRes=dibi::query("select id, article_date, title, short_text from article where parent_id=%i and label_id & %i and state=%i and deletedby=%i order by article_date desc", $mpID->id, 1, 1, 0); if(count($dataRes)>0) { foreach($dataRes as $dataRow) { $dd=date("j", strtotime($dataRow->article_date)); $mm=date("n", strtotime($dataRow->article_date)); $yy=date("Y", strtotime($dataRow->article_date)); echo "
$dataRow->title
"; else echo "id\" class=\"more\">více
"; echo "![\"div\"](\"img/action-div.png\")
\n";
}
} else echo "Neexistují žádné články";
} else echo "Článek neexistuje";
}
break;
case "zs-akce":
case "ms-akce":
case "babyklub-akce":
case "babyklub-vsehochut":
case "druzina-akce":
case "anglictina-akce":
if($_GET["id"]) {
$dataRow=dibi::fetch("select * from article where id=%i and state=%i and deletedby=%i", $_GET["id"], 1, 0);
if($dataRow->id) {
echo "
".date("j.n.Y", strtotime($dataRow->article_date))."
"; $url=str_replace("\\","/",$file); $name=substr($file,strrpos($file,"/")+1); $name=str_replace("-"," ",$name); $ext=substr($file,strrpos($file,".")+1); echo "
$name\n"; } } } } else echo "Požadovaný článek neexistuje."; $pg=$dataRow->id; } else { if($mpID->id) { if($_SESSION["PAGE"]=="babyklub-vsehochut") { $label=32; $dataRes=dibi::query ("select id, article_date, title, short_text from article where parent_id=%i and label_id & %i and state=%i and deletedby=%i order by article_date desc", $mpID->id, $label, 1, 0); } else { $label=2; $dataRes=dibi::query("select id, article_date, title, short_text from article where parent_id=%i and label_id & %i and state=%i and deletedby=%i and article_date>=now() order by article_date", $mpID->id, $label, 1, 0); } if(count($dataRes)>0) { // archiv akci echo "Archiv akcí"; foreach($dataRes as $dataRow) { if($_SESSION["PAGE"]=="babyklub-vsehochut") { $dtm=""; } else { $dd=date("j", strtotime($dataRow->article_date)); $mm=date("n", strtotime($dataRow->article_date)); $yy=date("Y", strtotime($dataRow->article_date)); $dtm="
";
}
echo "
\n";
}
}
} else echo "Článek neexistuje";
}
break;
case "zs-akce-archiv":
case "ms-akce-archiv":
case "babyklub-akce-archiv":
case "babyklub-vsehochut-archiv":
case "druzina-akce-archiv":
case "anglictina-akce-archiv":
if($_GET["id"]) {
$dataRow=dibi::fetch("select * from article where id=%i and state=%i and deletedby=%i", $_GET["id"], 1, 0);
if($dataRow->id) {
echo "
".date("j.n.Y", strtotime($dataRow->article_date))."
"; $url=str_replace("\\","/",$file); $name=substr($file,strrpos($file,"/")+1); $name=str_replace("-"," ",$name); $ext=substr($file,strrpos($file,".")+1); echo "
$name\n"; } } } } else echo "Požadovaný článek neexistuje."; $pg=$dataRow->id; } else { if($mpID->id) { if($_SESSION["PAGE"]=="babyklub-vsehochut") { $label=32; $dataRes=dibi::query ("select id, article_date, title, short_text from article where parent_id=%i and label_id & %i and state=%i and deletedby=%i order by article_date desc", $mpID->id, $label, 1, 0); } else { $label=2; $dataRes=dibi::query("select id, article_date, title, short_text from article where parent_id=%i and label_id & %i and state=%i and deletedby=%i order by article_date desc", $mpID->id, $label, 1, 0); } if(count($dataRes)>0) { foreach($dataRes as $dataRow) { if($_SESSION["PAGE"]=="babyklub-vsehochut") { $dtm=""; } else { $dd=date("j", strtotime($dataRow->article_date)); $mm=date("n", strtotime($dataRow->article_date)); $yy=date("Y", strtotime($dataRow->article_date)); $dtm="
";
}
echo "
\n";
}
}
} else echo "Článek neexistuje";
}
break;
case "babyklub-vsehochut":
if($_GET["id"]) {
$dataRow=dibi::fetch("select * from article where id=%i and state=%i and deletedby=%i", $_GET["id"], 1, 0);
if($dataRow->id) {
echo "
"; $url=str_replace("\\","/",$file); $name=substr($file,strrpos($file,"/")+1); $name=str_replace("-"," ",$name); $ext=substr($file,strrpos($file,".")+1); echo "
$name\n"; } } else echo "Stránka neobsahuje žádné dokumenty."; } else echo "Stránka neobsahuje žádné dokumenty."; } else echo "Požadovaný článek neexistuje."; } else { if($mpID->id) { // dibi::test ("select id, article_date, title, short_text from article where site_id=%i and label & %i order by article_date desc", $mpID->id, 2); $dataRes=dibi::query("select id, article_date, title, short_text from article where parent_id=%i and label_id & %i order by article_date desc", $mpID->id, 2); if(count($dataRes)>0) { foreach($dataRes as $dataRow) { $dd=date("j", strtotime($dataRow->article_date)); $mm=date("n", strtotime($dataRow->article_date)); echo " \n"; } } } else echo "Článek neexistuje"; } break; case "Xzs-dokumenty": case "Xms-dokumenty": case "Xdruzina-dokumenty": case "Xbabyklub-dokumenty": $documentsPath="ke-stazeni/dokumenty/$mpID->id/"; if(is_dir($documentsPath)) { $aFile=iterator_to_array(NFinder::findFiles('*')->in($documentsPath)); if(count($aFile)>0) { ksort($aFile); echo "
";
foreach ($aFile as $file) {
$url=str_replace("\\","/",$file);
$name=substr($file,strrpos($file,"/")+12);
$datum=date("j.n.Y", strtotime(substr($file,strrpos($file,"/")+1,10)));
$name=str_replace("-"," ",$name);
$ext=substr($file,strrpos($file,".")+1);
echo "
![\"stažení](\"img/download.png\")
\n";
$d[]="insert into article (parent_id, label_id, article_date, title, state, createdby) values ('$mpID->id', '4', '".date("Y-m-d", strtotime(substr($file,strrpos($file,"/")+1,10)))."', '$name', '1', '1');";
}
echo "";
echo implode("
",$d); } else echo "Stránka neobsahuje žádné dokumenty."; } else echo "Stránka neobsahuje žádné dokumenty."; echo "
"; break; case "zs-dokumenty": case "ms-dokumenty": case "druzina-dokumenty": case "babyklub-dokumenty": // dibi::test("select * from article where parent_id=%i and label_id & %i and state=%i and deletedby=%i order by article_date desc", $mpID->id, 4, 1, 0); $docRes=dibi::query("select * from article where parent_id=%i and label_id & %i and state=%i and deletedby=%i order by article_date desc", $mpID->id, 4, 1, 0); if(count($docRes)>0) { $documentsPath="ke-stazeni/clanky/$mpID->id"; echo "
";
foreach($docRes as $docRow) {
$url="$documentsPath/$docRow->id/";
if(file_exists($url)) {
$aFile=iterator_to_array(NFinder::findFiles('*')->in($url));
// var_dump($aFile);
foreach($aFile as $file) {
$url=str_replace("\\","/",$file);
$dwnld="";
}
} else $dwnld="";
$datum=date("j.n.Y", strtotime($docRow->article_date));
// $dwnld="Rozbalit složku";
echo "
\n";
}
echo "";
} else echo "Stránka neobsahuje žádné dokumenty.";
echo "
"; break; case "zs-jidelna": case "ms-jidelna": $jidelnaRes=dibi::query("select * from article where parent_id=%i and label_id & %i and state=%i and deletedby=%i order by article_date desc", $mpID->id, 16, 1, 0); if(count($jidelnaRes)>0) { $documentsPath="ke-stazeni/clanky/$mpID->id"; echo "
";
foreach($jidelnaRes as $jidelnaRow) {
$url="$documentsPath/$jidelnaRow->id/menu.doc";
$urlPDF="$documentsPath/$jidelnaRow->id/menu.pdf";
$name=substr($file,strrpos($file,"/")+12);
$datum=date("j.n.Y", strtotime(substr($file,strrpos($file,"/")+1,10)));
$name=str_replace("-"," ",$name);
$ext=substr($file,strrpos($file,".")+1);
if(file_exists(__DIR__."/$url")) $dwnld="";
if(file_exists(__DIR__."/$urlPDF")) $dwnld="";
echo "
\n";
}
echo "";
} else echo "Stránka neobsahuje žádné dokumenty.";
echo "
"; break; default: if($pageRow->perex) echo $pageRow->perex."
"; echo $pageRow->text; $pg=$pageRow->id; } //foto if(is_dir(__DIR__."/site-photo/".str_pad($pg, 4, "0", STR_PAD_LEFT))) { $dirs=iterator_to_array(NFinder::findFiles('*_sml.jpg')->in('site-photo/'.str_pad($pg, 4, "0", STR_PAD_LEFT))); if(count($dirs)>0) { echo "
"; echo "![](\"$fl?".(date("U"))."\")
\n";
}
}
}
?>
\n"; echo "
$dataRow->title
\n"; if($dataRow->short_text) echo "$dataRow->short_text
\n"; if($dataRow->text) echo "$dataRow->text
\n"; } else echo "Požadovaná fotogalerie neexistuje."; $pg=$dataRow->id; } else { if($mpID->id) { // dibi::test ("select id, article_date, title, short_text from article where site_id=%i and label & %i order by article_date desc", $mpID->id, 1); $dataRes=dibi::query("select id, article_date, title, short_text from article where parent_id=%i and label_id & %i and state=%i and deletedby=%i order by article_date desc", $mpID->id, 8, 1, 0); if(count($dataRes)>0) { foreach($dataRes as $dataRow) { $url="/site-photo/".str_pad($dataRow->id, 4, "0", STR_PAD_LEFT); $Fid=str_pad($dataRow->id, 4, "0", STR_PAD_LEFT); echo "title\">title\" />$dataRow->title\n";
}
} else echo "Stránka neobsahuje žádné fotogalerie.";
} else echo "Stránka neobsahuje žádné fotogalerie.";
}
break;
case "zs-clanky":
case "ms-clanky":
case "babyklub-aktuality":
case "druzina-clanky":
case "anglictina-clanky":
if($_GET["id"]) {
$dataRow=dibi::fetch("select * from article where id=%i and state=%i and deletedby=%i", $_GET["id"], 1, 0);
if($dataRow->id) {
echo "
".date("j.n.Y", strtotime($dataRow->article_date))."$dataRow->title
$dataRow->short_text
$dataRow->text
\n"; // vypis dokumentu $documentsPath="ke-stazeni/clanky/$mpID->id/$dataRow->id"; if(is_dir($documentsPath)) { $aFile=iterator_to_array(NFinder::findFiles('*')->in($documentsPath)); if(count($aFile)>0) { echo ""; ksort($aFile); foreach ($aFile as $file) { // echo $file."
"; $url=str_replace("\\","/",$file); $name=substr($file,strrpos($file,"/")+1); $name=str_replace("-"," ",$name); $ext=substr($file,strrpos($file,".")+1); echo "
$name\n"; } } } } else echo "Požadovaný článek neexistuje."; $pg=$dataRow->id; } else { if($mpID->id) { // dibi::test ("select id, article_date, title, short_text from article where parent_id=%i and label_id & %i and state=%i and deletedby=%i order by article_date desc", $mpID->id, 1, 1, 0); $dataRes=dibi::query("select id, article_date, title, short_text from article where parent_id=%i and label_id & %i and state=%i and deletedby=%i order by article_date desc", $mpID->id, 1, 1, 0); if(count($dataRes)>0) { foreach($dataRes as $dataRow) { $dd=date("j", strtotime($dataRow->article_date)); $mm=date("n", strtotime($dataRow->article_date)); $yy=date("Y", strtotime($dataRow->article_date)); echo "
".(strlen($dd)<2?" $dd":"$dd").".
".(strlen($mm)<2?" $mm":"$mm").".
$yy
$dataRow->short_text
"; if($_SESSION["MAINPAGE"]=="babyklub") echo "id\" class=\"more\">více"; else echo "id\" class=\"more\">více
"; echo "
$dataRow->title
$dataRow->short_text
$dataRow->text
\n"; // vypis dokumentu $documentsPath="ke-stazeni/clanky/$mpID->id/$dataRow->id"; if(is_dir($documentsPath)) { $aFile=iterator_to_array(NFinder::findFiles('*')->in($documentsPath)); if(count($aFile)>0) { ksort($aFile); foreach ($aFile as $file) { // echo $file.""; $url=str_replace("\\","/",$file); $name=substr($file,strrpos($file,"/")+1); $name=str_replace("-"," ",$name); $ext=substr($file,strrpos($file,".")+1); echo "
$name\n"; } } } } else echo "Požadovaný článek neexistuje."; $pg=$dataRow->id; } else { if($mpID->id) { if($_SESSION["PAGE"]=="babyklub-vsehochut") { $label=32; $dataRes=dibi::query ("select id, article_date, title, short_text from article where parent_id=%i and label_id & %i and state=%i and deletedby=%i order by article_date desc", $mpID->id, $label, 1, 0); } else { $label=2; $dataRes=dibi::query("select id, article_date, title, short_text from article where parent_id=%i and label_id & %i and state=%i and deletedby=%i and article_date>=now() order by article_date", $mpID->id, $label, 1, 0); } if(count($dataRes)>0) { // archiv akci echo "Archiv akcí"; foreach($dataRes as $dataRow) { if($_SESSION["PAGE"]=="babyklub-vsehochut") { $dtm=""; } else { $dd=date("j", strtotime($dataRow->article_date)); $mm=date("n", strtotime($dataRow->article_date)); $yy=date("Y", strtotime($dataRow->article_date)); $dtm="
".(strlen($dd)<2?" $dd":"$dd").".
".(strlen($mm)<2?" $mm":"$mm").".
$yy
$dataRow->title
$dataRow->short_text
$dataRow->text
\n"; // vypis dokumentu $documentsPath="ke-stazeni/clanky/$mpID->id/$dataRow->id"; if(is_dir($documentsPath)) { $aFile=iterator_to_array(NFinder::findFiles('*')->in($documentsPath)); if(count($aFile)>0) { ksort($aFile); foreach ($aFile as $file) { // echo $file.""; $url=str_replace("\\","/",$file); $name=substr($file,strrpos($file,"/")+1); $name=str_replace("-"," ",$name); $ext=substr($file,strrpos($file,".")+1); echo "
$name\n"; } } } } else echo "Požadovaný článek neexistuje."; $pg=$dataRow->id; } else { if($mpID->id) { if($_SESSION["PAGE"]=="babyklub-vsehochut") { $label=32; $dataRes=dibi::query ("select id, article_date, title, short_text from article where parent_id=%i and label_id & %i and state=%i and deletedby=%i order by article_date desc", $mpID->id, $label, 1, 0); } else { $label=2; $dataRes=dibi::query("select id, article_date, title, short_text from article where parent_id=%i and label_id & %i and state=%i and deletedby=%i order by article_date desc", $mpID->id, $label, 1, 0); } if(count($dataRes)>0) { foreach($dataRes as $dataRow) { if($_SESSION["PAGE"]=="babyklub-vsehochut") { $dtm=""; } else { $dd=date("j", strtotime($dataRow->article_date)); $mm=date("n", strtotime($dataRow->article_date)); $yy=date("Y", strtotime($dataRow->article_date)); $dtm="
".(strlen($dd)<2?" $dd":"$dd").".
".(strlen($mm)<2?" $mm":"$mm").".
$yy
$dataRow->title
$dataRow->short_text
$dataRow->text
\n"; // vypis dokumentu $documentsPath="ke-stazeni/clanky/$mpID->id/$dataRow->id"; if(is_dir($documentsPath)) { $aFile=iterator_to_array(NFinder::findFiles('*')->in($documentsPath)); if(count($aFile)>0) { ksort($aFile); foreach ($aFile as $file) { // echo $file.""; $url=str_replace("\\","/",$file); $name=substr($file,strrpos($file,"/")+1); $name=str_replace("-"," ",$name); $ext=substr($file,strrpos($file,".")+1); echo "
$name\n"; } } else echo "Stránka neobsahuje žádné dokumenty."; } else echo "Stránka neobsahuje žádné dokumenty."; } else echo "Požadovaný článek neexistuje."; } else { if($mpID->id) { // dibi::test ("select id, article_date, title, short_text from article where site_id=%i and label & %i order by article_date desc", $mpID->id, 2); $dataRes=dibi::query("select id, article_date, title, short_text from article where parent_id=%i and label_id & %i order by article_date desc", $mpID->id, 2); if(count($dataRes)>0) { foreach($dataRes as $dataRow) { $dd=date("j", strtotime($dataRow->article_date)); $mm=date("n", strtotime($dataRow->article_date)); echo " \n"; } } } else echo "Článek neexistuje"; } break; case "Xzs-dokumenty": case "Xms-dokumenty": case "Xdruzina-dokumenty": case "Xbabyklub-dokumenty": $documentsPath="ke-stazeni/dokumenty/$mpID->id/"; if(is_dir($documentsPath)) { $aFile=iterator_to_array(NFinder::findFiles('*')->in($documentsPath)); if(count($aFile)>0) { ksort($aFile); echo "
Název dokumentu
Datum
Stáhnout
$name
$datum
",$d); } else echo "Stránka neobsahuje žádné dokumenty."; } else echo "Stránka neobsahuje žádné dokumenty."; echo "
"; break; case "zs-dokumenty": case "ms-dokumenty": case "druzina-dokumenty": case "babyklub-dokumenty": // dibi::test("select * from article where parent_id=%i and label_id & %i and state=%i and deletedby=%i order by article_date desc", $mpID->id, 4, 1, 0); $docRes=dibi::query("select * from article where parent_id=%i and label_id & %i and state=%i and deletedby=%i order by article_date desc", $mpID->id, 4, 1, 0); if(count($docRes)>0) { $documentsPath="ke-stazeni/clanky/$mpID->id"; echo "
Název dokumentu
Zveřejněno
Stáhnout
";
}
} else $dwnld="";
$datum=date("j.n.Y", strtotime($docRow->article_date));
// $dwnld="Rozbalit složku";
echo "
$docRow->title
$datum
$dwnld
"; break; case "zs-jidelna": case "ms-jidelna": $jidelnaRes=dibi::query("select * from article where parent_id=%i and label_id & %i and state=%i and deletedby=%i order by article_date desc", $mpID->id, 16, 1, 0); if(count($jidelnaRes)>0) { $documentsPath="ke-stazeni/clanky/$mpID->id"; echo "
Název dokumentu
Stáhnout
";
if(file_exists(__DIR__."/$urlPDF")) $dwnld="";
echo "
$jidelnaRow->title
$dwnld
"; break; default: if($pageRow->perex) echo $pageRow->perex."
"; echo $pageRow->text; $pg=$pageRow->id; } //foto if(is_dir(__DIR__."/site-photo/".str_pad($pg, 4, "0", STR_PAD_LEFT))) { $dirs=iterator_to_array(NFinder::findFiles('*_sml.jpg')->in('site-photo/'.str_pad($pg, 4, "0", STR_PAD_LEFT))); if(count($dirs)>0) { echo "
"; echo "
